Trying to bulk load a SAS data set into a Google BigQuery database might result in the following error:

This issue occurs when the data begin or ends with quotation marks. 

 

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Data Connector to Google BigQuery	Linux for x64	V.03.05	2020.1	Viya	Viya
SAS System	SAS/ACCESS Interface to Google BigQuery	Linux for x64	9.41	9.42	9.4 TS1M6	9.4 TS1M7

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at

http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates

---

A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.41 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/H5A.html#65886

---

When you bulk load data into a Google BigQuery database, you might encounter this error: "Error while reading data, error message: CSV table encountered too many errors, giving up...Error detected while parsing row starting at position: 0...Data between close double quote (") and field separator..."

Type:	Problem Note
Priority:	high

Date Modified:	2020-05-01 09:00:17
Date Created:	2020-04-27 16:52:05